Internet Magazine 2002 June/INTERNET92.ISO/pc/software/windows/utils/mysql_studio/winstudio_setup.exe/{app}/myodbc/Change.log

Text File | 2002-01-31 | 17.9 KB | 505 lines

2001-08-15  Michael Widenius  <[e-mail]>

* Release of 3.23.38
* SQLSetCursorName
* SQLGetCusrorName
* SQLSetPos
* Positioned update/delete operations

2001-06-02  Michael Widenius  <[e-mail]>

* Added code to SQLGetTypeInfo() to force access to use TEXT for it's
  VARCHAR columns (instead of 'SET').

2001-04-20  Michael Widenius  <[e-mail]>

* Release of 3.23.37
* Support for transactions:  SQLTransact(), SQLSetConnectOption(AUTOCOMMIT),
  SQLSetConnectOption(SQL_TXN_ISOLATION), SQLGetInfo().
* Add that MySQL can do ORDER BY on functions.

2001-02-15  Michael Widenius  <[e-mail]>

* Fixed that configure searches after libmysqlclient in /usr/lib/mysql

2000-10-21  Michael Widenius  <[e-mail]>

* When retrieving a bound integer (0-9) that was followed
  with a string that looked like a date, (1, '##-##-##', the integer
  wasn't retrieved correctly (bug found by Daniel Giddings).

2000-10-19  Michael Widenius  <[e-mail]>

* Fixed support of MEMO fields in Delphi with 'Cached Updates'
*  Changed names for windows .dlls;  myodbc.dll is now the optimized driver
   while myodbcd.dll is compiled for debugging and tracing.

2000-10-16  Michael Widenius  <[e-mail]>

* Fixed configure problem with my_config.h
  By Ralf Fassel <[e-mail]>
* Fixed that the correct connect error message is displayed.
  Found by Ralf Fassel <[e-mail]>

2000-10-03  Michael Widenius  <[e-mail]>

* Release of MyODBC 2.50.34

2000-09-26  Michael Widenius  <[e-mail]>

* Removed the BOOL typedef

2000-09-20  Michael Widenius  <[e-mail]>

* Changed that data truncation messages will be saved on the stmt
  level instead of on the connect level (pointed out by Lawrence Reisler).

2000-09-16  Michael Widenius  <[e-mail]>

* Only return the quote identfier ` when connecting to MySQL 3.23

2000-09-01  Michael Widenius  <[e-mail]>

* Release of MyODBC 2.50.33

2000-09-01  Michael Widenius  <[e-mail]>

* When using MySQL 3.23, report that one can quote identifiers with `.
  This goes around the bug in Access 2000 that table and column names
  are missing when exporting data to MySQL

2000-08-20  Michael Widenius  <[e-mail]>

* Release of MyODBC 2.50.32
* Changed code to use __WIN__ and _WIN32 defines
* Added detection of libz to configure

2000-08-18  Michael Widenius  <[e-mail]>

* When one used SQLBindParameter() on binding a not null terminated string
  to a double, we copied one char too much to the result.

2000-08-14  Michael Widenius  <[e-mail]>

* Fix of overflow problem when extending buffer when escaping big strings.
  (Fix by "Pearson, Doug").

2000-08-11  Michael Widenius  <[e-mail]>

* Fix that MyODBC reads all arguments from ConfigDSN (fix by
  John P. Petrakis)

2000-04-11  Michael Widenius  <[e-mail]>

* Release of 3.50.31
* Changed MyODBC to use new functions from MySQL 3.23.14 to make it
  more character set independent.

2000-04-03  Michael Widenius  <[e-mail]>

* Changed SQLGetInfo(SQL_QUOTED_IDENTIFIER_CASE) to return SQL_IC_SENSITIVE
  instead of SQL_IC_MIXED.

2000-03-17  Michael Widenius  <[e-mail]>

* Release of 2.50.30
* Fixed problem with " within strings;  Thanks to Gerry Sweeney for
  noticing this!

2000-03-09  [e-mail]

* Added support for Japanese characters (USE_MB).

2000-02-21  Michael Widenius  <[e-mail]>

* Fixed strtok() in SQLConnect() to make it threadsafe and not crash memory
  on Unix.

2000-01-11  Michael Widenius  <[e-mail]>

* Fixed connect() to not make a trace file if you have Trace=OFF in your
  .odbc.ini file.
* Changed SQLGetTypeInfo to return 'mediumint' instead of 'middleint'.

1999-11-23  Michael Widenius  <[e-mail]>

* Fixed problem with TIMESTAMP query parameters.

1999-11-16  Michael Widenius  <[e-mail]>

* Fix for handling SQL_FLOAT parameters (bug report from Microsoft)

1999-11-13  Matt Wagner  <[e-mail]>

* RPM for MyODBC

1999-11-12  Michael Widenius  <[e-mail]>

* Release of 2.50.28 for Win32

1999-11-11  Michael Widenius  <[e-mail]>

* Added some checking to ensure that SQL_DATE parameters have ' around them.
* Added missing SQL_COLUMN_TABLE_NAME to SQLColAttributes.
* Changed the parameter escape handling to use functions in libmysqlclient
  to make MyODBC independent of the character set (like BIG5).

1999-10-01  Michael Widenius  <[e-mail]>

* Added mutex lock around all use of DBC;  This should make MyODBC thread safe
  even for multiple threads share the same connection.
* MyODBC now uses libmysqlclient from MySQL 3.23.  One can now configure
  MyODBC without having to install the MySQL source.

1999-09-15  Michael Widenius  <[e-mail]>

* Some small fixes in configure to help it find libmysqlclient.a

Fri Sep  3 13:34:02 1999  Michael Widenius  <[e-mail]>

* Release of 3.22.25

1999-07-01  Michael Widenius  <[e-mail]>

* Fix for SQLSetStmtOption to return SQL_SUCCESS_WITH_INFO instead of
  SQL_ERROR if MyODBC changes the requested cursor type.
* Changed debugging to not clear the debug file on restart.

1999-06-27  Michael Widenius  <[e-mail]>

* Added a wrapper around SQLFreeStmt to avoid linker problems.

1999-06-07  Michael Widenius  <[e-mail]>

* Added test if ODBC debugging is requested on SQLConnect()
  (Thanks for Peter Harvey for this)

1999-06-06  Michael Widenius  <[e-mail]>

* Release of 3.22.24
* Added test of SQL_BESTROW_ID in SQLSpecialColumns

1999-06-03  Michael Widenius  <[e-mail]>

* The MyODBC driver never reported that a column is updatable when calling
  SQLColAttributes. (Patch by [e-mail])

1999-05-14  Michael Widenius  <[e-mail]>

* Fixed of 'Invalid cursor name Data truncated'
* Changed the FLAG connect option to OPTION (to be consistent with the Unix
  MyODBC version)

1999-05-01  Michael Widenius  <[e-mail]>

* Patch for big floats (by Dmitry Potapov <[e-mail]>)

1999-04-27  Michael Widenius  <[e-mail]>

* Release of 3.22.23

1999-04-27  Manush Dodunekov  <[e-mail]>
* configure.in: Added option --with-odbc-ini=PATH
* misc.c: Modified to look for odbc.ini in the iodbc way.

1999-04-21  Manush Dodunekov  <[e-mail]>

* connect.c (SQLConnect): Initial statement now defaults to
  "", not "0". Connect flag is read from "option", not "flag".
  Connect-string keywords are now case insensitive on Unix.

* info.c (SQLGetInfo): Return mysql version instead of driver version
  with SQLGetInfo(SQL_DBMS_VER)

* Prepared for future libiodbcinst, provided is a temporary
  ini file reader - no patch to iodbc needed.

1999-04-20  Manush Dodunekov <[e-mail]>

* Ported MyODBC to IODBC.  Did also the following changes:

SWORD -> SQLSMALLINT
UWORD -> SQLUSMALLINT
SDWORD -> SQLINTEGER
UDWORD -> SQLUINTEGER
PTR -> SQLPOINTER
UCHAR -> SQLCHAR
HENV -> SQLHENV
HDBC -> SQLHDBC
HSTMT -> SQLHSTMT

1999-04-20  Lars Doelle <[e-mail]>

* Patch to make myodbc use the odbc.ini entries.

The following is the ChangeLog before the port to libiodbc:

2.50.23

- SQLGetStmtOption() with SQL_ROW_NUMBER is now 1 based.
- SQLColAttributes() called with SQL_COLUMN_COUNT on something that didn't
  return a result set crashed.

2.50.22a
- Fixed type error in result.c

2.50.22:
- Don't release bound columns until SQLFreeStmt with SQL_UNBIND or SQL_DROP.
- Don't give an error with MySQL 3.21 when checking if the connection is up.
- Force initialization of threads even if the application doesn't call
  LibMain() with DLL_THREAD_ATTACH.
- Added BINARY -> CHAR conversion for BLOBS.

2.50.21:
- Changed SQLGetData to not add end null to binary data that
  must be retrieved trough many SQLGetData calls.
  (The old way should have worked, but Mike Watson reported
  some problems with Access that this patch should fix)
- Added an ODBC connect option to make one SQL query at connection.
  This is useful to tell the MySQL server to use a specific character set
  when connecting.
- Upgraded the MySQL interface to 3.22.10 (To support the new options flags)

2.50.20:
- Added mapping of MySQL error codes in connect and query to
  ODBC error codes.
- Some small changes of handling CATALOGS with SQLGetInfo()
- Compressed protcol didn't work because MEMMOVE wasn't defined.
- Allow one to call SQLColAttribute with col=0 and
  type = SQL_DESC_COUNT (needed by odbcexpress).

2.50.19:
- When using SQLSetStmtOption with SQL_CURSOR_TYPE one could get
  'data truncated' errors when retrieving data.
- MyODBC 2.50.18 crashed when trying to connect from some clients.

2.50.18:
- Added option flag for extension of SQLDescribeCol
- One can now bind LONG to date columns (ODBC extension)
- MyODBC crashed when one used the following combination:
  SQLPrepare/SQLBindParameter/SQLExectute/SQLFreeSTMT(SQL_RESET_PARAM)/
  SQLBindParameter.
- Updated MySQL API to 3.22.8 with named pipe support and compression.
- Now options flags (see above)
- New nice interface to the options flags from the MyODBC connect screen.
- MyODBC now reports to MySQL that this is a ODBC client, which allows
  MySQL 3.22.7 and above to behave differently to satisfy weird requests.
- If there is more than one hour since last query, MyODBC will now check
  that the connection is ok and do a reconnect if needed.

2.50.17
- DATE fields was updated with DATE + TIME (bug from 2.50.16)
- BLOB fields are now returned as LONGVARBINARY instead of LONGVARCHAR.
  TEXT fields are still returned as LONGVARCHAR.
  (Patch by "Shayne Hughes" <[e-mail]>)

2.50.16
- Lots of extra parameter checking for safer code with different drivers.
- Format MySQL timestamp columns when converted to ODBC strings.
  (YYYYMMDDHHMMSS -> YYYY-MM-DD HH:MM:SS)
- Allow NULL values in auto increment columns (for Delphi 3.0)
- Added option to pad character fields with space to max length (for
  quiktest.dll)
- Fixes bind problems from 2.50.15
  NOTE: If you have problems with 2.50.16, the most stable version is 2.50.13 !
- SQLExtended_fetch() couldn't always read from overlapping start region

2.50.15
- Fixed a problem with Excel and SQLTables() from 2.50.14.
- Changed SQLBindCol() to allow one to remove old value bindings but keep
  length bindings (very seldom used, but required by the ODBC standard)
- Allow one to use SQL_CURSOR_FORWARD and SQL_CURSOR_STATIC. Fixes problem
  with ASP.
- Change locale for SQL parameters and bound float/double variables to allow
  one to have ',' as decimal point in ones locale!
  Fix also locale for all SQL parameters that are inserted as CHAR but
  requested as DOUBLE. (To fix money type in Access 97)
- If name is truncated, now return the truncated length instead of the original
  length (because of the perl DBI/ODBC driver).
- Allow one to SQLBindCol() before SQLPrepare() because of VB 5.0
  (Who came up with this BROKEN standard ?)

2.50.14
- Some small changes to SQLTable() to get some ODBC applications to work.
  Now one can request catalog names, schema names and table types from
  SQLTable().
- Added support for the new YEAR type in MySQL 3.22.
- Added support to turn of schemas in MySQL 3.22 (In MySQL 3.22 schema =
  database)
- Different releases for win95 and NT to avoid installation problems on NT.
- Added option to force use of ODBC manager cursors (See the option flag table)

2.50.13
- Added SQLGetInfo(SQL_OJ_CAPABILITIES).
- Added option flag 32
- Fixed bug with SQLGetInfo(DATABASE_NAME = 16) from MyODBC 2.50.12

2.50.12
- Change 0000-00-00 DATE values to NULL if retrieved as DATE.
- SQLParameter() extended to support all ODBC 2.50 parameter types.
- Using new connect protocol for MyODBC 3.21.26 to make faster connections.
- Don't remove \r\n from SQL statement.
- Added option flag 16

2.50.11
- SQLColumns() didn't return right column lengths().
- SQLColumns() on BLOBS columns now returns max blob length.
- SQLGetInfo() now reports that MySQL supports allmost all DATE functions.
- Fixed problem that some applications (at least PowerBuilder) uses wrong
  max column lengths for fixed types to SQLBindCol().

2.50.10
- Added support for SQLNativeSQL.
- SQLGetInfo() didn't report that MyODBC supports SQLGetConnectoption.
- Allow SQLBind() to be called before SQLExecute().

2.50.9
- VB5 does a wrong 'SELGetInfo' request where the save address is 0x.  Requests
  like these are now silenty ignored.
- SQLDescribParam() implemented by always returning VARCHAR(255). As MySQL
  can take strings anywhere this should be a workable solution!
- Changed password to allow 16 characters (was 8).

2.50.8
- More debug information to the MyODBC log.

2.50.7
- Upgraded libmysql.c to allow automatic reconnection in some cases.
- Fixed problems in SQLExtendedFetch() and SQLGetTypeInfo() that crashed
  Delphi 3.0
- DATETIME now return timestamp as default value (crashed Access)
- The distribution now contains include files and libraries for use
  with C clients.  One have to link with all included .lib files
  to get a C client.
- Use my_SQLExecute instead of SQLExecute to avoid dynamic link problems
  on some Unix systems.
- Extended SQLSetConnectOPtion and SQLGetConnectOptions to handle all
  options (some are silently ignored).
- SQLGetStmtOption now handles all ODBC 2.5 options.

2.50.6
- Report the MySQL have LEFT OUTER JOIN and all other functions from
  MySQL 3.21.17

2.50.5
- Fixed better logging by changing ASCII 0 to \0 when inserting parameters.
- Optimized 'mysql_list_tables' to not call malloc so many times.

2.50.4
- Added Option bits FLAG_BIG_PACKETS and FLAG_DEBUG
- Fixed bug with longvarbinary parameters with ASCII 0

2.50.3:
- Added Option 2 for Access, see NOTES.
- Fixed bug with date fields and Access.

2.50.2:
- Fixed DATETIME and TIME problems when using SQLBind.
- Fixed that port is saved properly.
- Added options flag for some BDE drivers. Options = 1 tells MyODBC not to
  return max_width for columns. This should help Delphi connections.
- Changed SqlColumns(), SqlSpecialColumns() and SqlColAttributes() to return
  right transfer size.
- TIMESTAMP now always returns precision 19 (because of BDE).
- Added conversion for the DISPLAY_SIZE for SQLColAttributes

2.50.1:
- The installer got linked with the ODBC 3.0 libraries and didn't work.
  Fixed by relinking with ODBC 2.50.

2.50.0:
- MyODBC has now tags for ODBC 3.0, but because ODBC 3.0 hasn't a ODBC
  installer, MyODBC is still 2.5 based).
- This version works with MySQL 3.20 and MySQL 3.21 servers.
- Updated SQLGetInfo to report all new MySQL functions.
- Added database name to the driver setup.
- Timestamp(12), timestamp(8) and timestamp(6) should now work.
- Added column number check to SQLColAttributes and SQLDescribeCol.
- Added support of SQLExtendedfetch and SQLSetScrollOptions and SQLSetPos.
- Added pre-evaluation of query in SQLDescribeCol, SQLNumResultCols and
  SQLColAttributes.
- SQLGetDATA now correctly allows one to retrieve a BLOB in parts with many
  calls.
- SQLTables now returns a empty set instead of an error when doing a request
  for only VIEWS.
- Fixed lots of bugs in Microsoft example application admndemo.
  Hope the ODBC driver manager (also by Microsoft) is not this buggy!!!!!
- Extended SQLSetStmtOption() to handle SQL_ROWSET_SIZE.

1.0.19
- Fixed bug in SQLColAttributes. This bug at least affected Access97 to
  return to short fields.
- Extended host name to 60 characters and user name to 16.

1.0.18
- Added missing SQLGetInfo(SQL_TXN_ISOLATION_OPTION) option.
- SQLTables() now search after table qualifier TABLE instead of 'TABLE'
- Changed max client package to 512K

1.0.17
- Added new ODBC 2.5 columns to results of SQlSpecialColumns, SQLPrimaryKeys
  and SQLForeignKeys.
- Removed convert of password to lower case in login dialog.
- Added new column definitions from Wim Bonis and Giovanni Maruzzelli.

1.0.16
- Fixed SQLSpecialColumns (line was missing from 1.0.14)
- Removed precision and scale from double and float to get Access to work
  better.

1.0.15
- Added patches by Giovanni Maruzzelli and Wim Bonis to fix TIMESTAMP, DATE,
  TIME and DATETIME fields.
- SqlSpecialColumns now uses TIMESTAMP as ROWID.

1.0.14
- SQLPutInfo tried to use the memory pointer passed. Now it always makes a copy.
- Added support for the new MySQL DATE and TIME types.
- Blob's with ASCII 0 can now be read.
- Updated libraries from MySQL 3.20.13.

1.0.13
- Password is now longer regarded 'required' in the loggin screen.
- If port is 0 or not given then myodbc defaults to the default port (3333).
- Fixed that '?' is not regarded a parameter in strings.

1.0.12
- Added keywords KEYS, RLIKE to SQLGetInfo.
- Fixed some wrong definitions with TINYBLOB.
- Removed old memory allocation from 1.0.11.
- Added support for SQL_SEND_LEN_DATA_AT_EXEC parameters. This fixed updating of blobs in Access.
- Enlarged communication buffer to 16384.

1.0.11
- Some statement fields where not cleared in SQLGetColumns and SQLTables.
  This resulted in failed second queries.
- Implemented SQLGetStmtOption. (Needed for Access)
- SQLStatistics returned wrong column count.
- Changed default types for SQLStatistics and SQLColumns. (I hate ODBC default types!)
- Added lots of more debug statements.
- Fixed parameter bug in SQLExecute (found by Giovanni).
- Fixed some definition bugs in SQLFreeStmt.
- Tested with Access:  The following should work:
  Attach (link tables), search, insert, delete and update.

1.0.10
- Changed return of SQLGetInfo SQL_ODBC_API_CONFORMANCE from long to short.

1.0.9
- Update with bind parameters didn't work for strings. This made MSquery fail
  on insert and update.
- Added info about all new ODBC functions in server 3.20.0

1.0.7
- Lie that we can handle transactions and set/get cursor names. One should
  use ODBC cursors with MyODBC!

1.0.6
- Fixed some small bugs to allow connection from Delphi.
- Fixed windows password bug (passwords should work)

1.0.4
- Added all ODBC level 2 options to SQLGetData + 2 options from ODBC level 1.
- Fixed bug when adding limit to select clause: if SQL_MAX_ROWS was MAX_INT
  then limit was set to -1.